Pandas Profiling Report

Dataset info

Number of variables	49
Number of observations	200000
Missing cells	694994 (7.1%)
Duplicate rows	0 (0.0%)
Total size in memory	69.3 MiB
Average record size in memory	363.2 B

Variables types

Numeric	13
Categorical	18
Boolean	15
Date	0
URL	0
Text (Unique)	1
Rejected	2
Unsupported	0

Warnings

`de_faixa_faturamento_estimado` has 11885 (5.9%) missing values	Missing
`de_faixa_faturamento_estimado_grupo` has 11885 (5.9%) missing values	Missing
`de_natureza_juridica` has a high cardinality: 63 distinct values	Warning
`de_nivel_atividade` has 4721 (2.4%) missing values	Missing
`de_saude_rescencia` has 6356 (3.2%) missing values	Missing
`de_saude_tributaria` has 6356 (3.2%) missing values	Missing
`dt_situacao` has a high cardinality: 6495 distinct values	Warning
`empsetorcensitariofaixarendapopulacao` has 62448 (31.2%) missing values	Missing
`fl_epp` has constant value "False"	Rejected
`fl_optante_simei` has 35727 (17.9%) missing values	Missing
`fl_optante_simples` has 35727 (17.9%) missing values	Missing
`idade_media_socios` has 65438 (32.7%) missing values	Missing
`nm_divisao` has a high cardinality: 87 distinct values	Warning
`nm_meso_regiao` has 25254 (12.6%) missing values	Missing
`nm_micro_regiao` has a high cardinality: 74 distinct values	Warning
`nm_micro_regiao` has 25254 (12.6%) missing values	Missing
`nu_meses_rescencia` has 19547 (9.8%) missing values	Missing
`qt_filiais` has 180959 (90.5%) zeros	Zeros
`qt_socios` is highly skewed (γ1 = 26.71097273)	Skewed
`qt_socios` has 49616 (24.8%) missing values	Missing
`qt_socios_feminino` is highly skewed (γ1 = 56.06299548)	Skewed
`qt_socios_feminino` has 137299 (68.6%) missing values	Missing
`qt_socios_masculino` is highly correlated with `qt_socios` (ρ = 0.9711913029)	Rejected
`qt_socios_pj` has 148477 (74.2%) zeros	Zeros
`qt_socios_pj` has 49616 (24.8%) missing values	Missing
`vl_faturamento_estimado_aux` is highly skewed (γ1 = 346.5212661)	Skewed
`vl_faturamento_estimado_aux` has 11885 (5.9%) missing values	Missing
`vl_faturamento_estimado_grupo_aux` is highly skewed (γ1 = 28.13600343)	Skewed
`vl_faturamento_estimado_grupo_aux` has 11885 (5.9%) missing values	Missing
`vl_total_veiculos_leves_grupo` is highly skewed (γ1 = 35.27165009)	Skewed
`vl_total_veiculos_leves_grupo` has 183714 (91.9%) zeros	Zeros
`vl_total_veiculos_pesados_grupo` is highly skewed (γ1 = 27.93113919)	Skewed
`vl_total_veiculos_pesados_grupo` has 191111 (95.6%) zeros	Zeros

de_faixa_faturamento_estimado
Categorical

Distinct count	13
Unique (%)	< 0.1%
Missing (%)	5.9%
Missing (n)	11885

DE R$ 81.000,01 A R$ 360.000,00	118455
ATE R$ 81.000,00	42719
DE R$ 360.000,01 A R$ 1.500.000,00	20014
Other values (9)	6927
(Missing)	11885

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DE R$ 81.000,01 A R$ 360.000,00	118455	59.2%
ATE R$ 81.000,00	42719	21.4%
DE R$ 360.000,01 A R$ 1.500.000,00	20014	10.0%
DE R$ 1.500.000,01 A R$ 4.800.000,00	4384	2.2%
DE R$ 4.800.000,01 A R$ 10.000.000,00	906	0.5%
DE R$ 10.000.000,01 A R$ 30.000.000,00	629	0.3%
SEM INFORMACAO	507	0.3%
DE R$ 30.000.000,01 A R$ 100.000.000,00	352	0.2%
DE R$ 100.000.000,01 A R$ 300.000.000,00	111	0.1%
DE R$ 300.000.000,01 A R$ 500.000.000,00	21	< 0.1%
Other values (2)	17	< 0.1%
(Missing)	11885	5.9%

Max length	40
Mean length	26.56831
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_faixa_faturamento_estimado_grupo
Categorical

Distinct count	12
Unique (%)	< 0.1%
Missing (%)	5.9%
Missing (n)	11885

DE R$ 81.000,01 A R$ 360.000,00	109328
ATE R$ 81.000,00	42512
DE R$ 360.000,01 A R$ 1.500.000,00	23065
Other values (8)	13210
(Missing)	11885

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DE R$ 81.000,01 A R$ 360.000,00	109328	54.7%
ATE R$ 81.000,00	42512	21.3%
DE R$ 360.000,01 A R$ 1.500.000,00	23065	11.5%
DE R$ 1.500.000,01 A R$ 4.800.000,00	5858	2.9%
DE R$ 4.800.000,01 A R$ 10.000.000,00	1768	0.9%
DE R$ 10.000.000,01 A R$ 30.000.000,00	1622	0.8%
ACIMA DE 1 BILHAO DE REAIS	1507	0.8%
DE R$ 30.000.000,01 A R$ 100.000.000,00	1272	0.6%
DE R$ 100.000.000,01 A R$ 300.000.000,00	660	0.3%
DE R$ 500.000.000,01 A 1 BILHAO DE REAIS	291	0.1%
(Missing)	11885	5.9%

Max length	40
Mean length	26.816375
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_natureza_juridica
Categorical

Distinct count	63
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

EMPRESARIO INDIVIDUAL	127984
SOCIEDADE EMPRESARIA LIMITADA	39432
ASSOCIACAO PRIVADA	12883
Other values (60)	19701

Toggle details

Common values
Composition

Value	Count	Frequency (%)
EMPRESARIO INDIVIDUAL	127984	64.0%
SOCIEDADE EMPRESARIA LIMITADA	39432	19.7%
ASSOCIACAO PRIVADA	12883	6.4%
EMPRESA INDIVIDUAL DE RESPONSABILIDADE LIMITADA DE NATUREZA EMPRESARIA	6560	3.3%
ORGAO DE DIRECAO LOCAL DE PARTIDO POLITICO	3129	1.6%
ORGANIZACAO RELIGIOSA	1275	0.6%
SOCIEDADE ANONIMA FECHADA	949	0.5%
CONDOMINIO EDILICIO	887	0.4%
ENTIDADE SINDICAL	770	0.4%
CANDIDATO A CARGO POLITICO ELETIVO	693	0.3%
Other values (53)	5438	2.7%

Max length	70
Mean length	24.489855
Min length	9
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_nivel_atividade
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	2.4%
Missing (n)	4721

MEDIA	94617
ALTA	65726
BAIXA	32889
(Missing)	4721

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MEDIA	94617	47.3%
ALTA	65726	32.9%
BAIXA	32889	16.4%
MUITO BAIXA	2047	1.0%
(Missing)	4721	2.4%

Max length	11
Mean length	4.68557
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_ramo
Categorical

Distinct count	33
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

COMERCIO VAREJISTA	74773
SERVICOS DIVERSOS	26040
SERVICOS DE ALOJAMENTO/ALIMENTACAO	13022
Other values (30)	86165

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMERCIO VAREJISTA	74773	37.4%
SERVICOS DIVERSOS	26040	13.0%
SERVICOS DE ALOJAMENTO/ALIMENTACAO	13022	6.5%
INDUSTRIA DA CONSTRUCAO	11037	5.5%
COMERCIO E REPARACAO DE VEICULOS	9633	4.8%
BENS DE CONSUMO	9311	4.7%
SERVICOS ADMINISTRATIVOS	9216	4.6%
SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	7452	3.7%
COMERCIO POR ATACADO	7092	3.5%
TRANSPORTE, ARMAZENAGEM E CORREIO	6618	3.3%
Other values (23)	25806	12.9%

Max length	49
Mean length	22.054005
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

de_saude_rescencia
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	3.2%
Missing (n)	6356

ACIMA DE 1 ANO	163960
ATE 1 ANO	16486
SEM INFORMACAO	13191
Other values (2)	7
(Missing)	6356

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ACIMA DE 1 ANO	163960	82.0%
ATE 1 ANO	16486	8.2%
SEM INFORMACAO	13191	6.6%
ATE 3 MESES	6	< 0.1%
ATE 6 MESES	1	< 0.1%
(Missing)	6356	3.2%

Max length	14
Mean length	13.238165
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

de_saude_tributaria
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	3.2%
Missing (n)	6356

VERDE	62976
AZUL	45670
AMARELO	39297
Other values (3)	45701

Toggle details

Common values
Composition

Value	Count	Frequency (%)
VERDE	62976	31.5%
AZUL	45670	22.8%
AMARELO	39297	19.6%
CINZA	27688	13.8%
LARANJA	15616	7.8%
VERMELHO	2397	1.2%
(Missing)	6356	3.2%

Max length	8
Mean length	5.293175
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

dt_situacao
Categorical

Distinct count	6495
Unique (%)	3.2%
Missing (%)	< 0.1%
Missing (n)	2

2005-11-03	30087
2006-12-21	967
2006-12-01	891
Other values (6491)	168053

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2005-11-03	30087	15.0%
2006-12-21	967	0.5%
2006-12-01	891	0.4%
2010-05-15	771	0.4%
2005-09-24	679	0.3%
2006-12-02	645	0.3%
1998-07-28	644	0.3%
2005-08-27	584	0.3%
2004-10-30	408	0.2%
2001-07-01	390	0.2%
Other values (6484)	163932	82.0%

Max length	10
Mean length	9.99993
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

empsetorcensitariofaixarendapopulacao
Numeric

Distinct count	14072
Unique (%)	7.0%
Missing (%)	31.2%
Missing (n)	62448
Infinite (%)	0.0%
Infinite (n)	0

Mean	1302.532581
Minimum	100
Maximum	75093.84
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	100
5-th percentile	424.291
Q1	670.68
Median	944.94
Q3	1511.81
95-th percentile	3516.495
Maximum	75093.84
Range	74993.84
Interquartile range	841.13

Descriptive statistics

Standard deviation	1147.151209
Coef of variation	0.8807082641
Kurtosis	409.4083295
Mean	1302.532581
MAD	715.9528233
Skewness	9.22983695
Sum	179165961.7
Variance	1315955.896
Memory size	3.1 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1549.1	864	0.4%
2361.38	363	0.2%
1086.05	317	0.2%
3940.05	241	0.1%
786.74	211	0.1%
3321.86	206	0.1%
2679.5	198	0.1%
2019.39	196	0.1%
1692.92	194	0.1%
1910.81	191	0.1%
Other values (14061)	134571	67.3%
(Missing)	62448	31.2%

Minimum 5 values

Value	Count	Frequency (%)
100	2	< 0.1%
110.3	24	< 0.1%
151.35	1	< 0.1%
169.28	18	< 0.1%
172.68	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
75093.84	3	< 0.1%
30861.81	8	< 0.1%
13793	10	< 0.1%
12512.93	51	< 0.1%
11281.03	2	< 0.1%

fl_antt
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	792

False	197819
True	1389
(Missing)	792

Toggle details

Value	Count	Frequency (%)
False	197819	98.9%
True	1389	0.7%
(Missing)	792	0.4%

fl_email
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	110674
True	89326

Toggle details

Value	Count	Frequency (%)
False	110674	55.3%
True	89326	44.7%

fl_epp
Constant

This variable is constant and should be ignored for analysis

Constant value	False

fl_ltda
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	199478
True	522

Toggle details

Value	Count	Frequency (%)
False	199478	99.7%
True	522	0.3%

fl_matriz
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

True	187468
False	12532

Toggle details

Value	Count	Frequency (%)
True	187468	93.7%
False	12532	6.3%

fl_me
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	199515
True	485

Toggle details

Value	Count	Frequency (%)
False	199515	99.8%
True	485	0.2%

fl_mei
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	134640
True	65360

Toggle details

Value	Count	Frequency (%)
False	134640	67.3%
True	65360	32.7%

fl_optante_simei
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	17.9%
Missing (n)	35727

False	123510
True	40763
(Missing)	35727

Toggle details

Value	Count	Frequency (%)
False	123510	61.8%
True	40763	20.4%
(Missing)	35727	17.9%

fl_optante_simples
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	17.9%
Missing (n)	35727

True	86493
False	77780
(Missing)	35727

Toggle details

Value	Count	Frequency (%)
True	86493	43.2%
False	77780	38.9%
(Missing)	35727	17.9%

fl_passivel_iss
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	792

True	114393
False	84815
(Missing)	792

Toggle details

Value	Count	Frequency (%)
True	114393	57.2%
False	84815	42.4%
(Missing)	792	0.4%

fl_rm
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

NAO	102598
SIM	97402

Toggle details

Common values
Composition

Value	Count	Frequency (%)
NAO	102598	51.3%
SIM	97402	48.7%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

fl_sa
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	196383
True	3617

Toggle details

Value	Count	Frequency (%)
False	196383	98.2%
True	3617	1.8%

fl_simples_irregular
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	792

False	199046
True	162
(Missing)	792

Toggle details

Value	Count	Frequency (%)
False	199046	99.5%
True	162	0.1%
(Missing)	792	0.4%

fl_spa
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	792

False	199109
True	99
(Missing)	792

Toggle details

Value	Count	Frequency (%)
False	199109	99.6%
True	99	< 0.1%
(Missing)	792	0.4%

fl_st_especial
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	199967
True	33

Toggle details

Value	Count	Frequency (%)
False	199967	> 99.9%
True	33	< 0.1%

fl_telefone
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

True	145216
False	54784

Toggle details

Value	Count	Frequency (%)
True	145216	72.6%
False	54784	27.4%

fl_veiculo
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	792

False	186018
True	13190
(Missing)	792

Toggle details

Value	Count	Frequency (%)
False	186018	93.0%
True	13190	6.6%
(Missing)	792	0.4%

id
Categorical, Unique

First 5 values
000001857eec66f7d67ea918825c9980eebff5c10b36f3...
0000133f443484b40bc632e3b8595c8348441b3899973f...
000061121bf1a98d79c02f156af0cadec80ea1c68236e6...
0000bf5a53db23cf7ccbe510f95c423b97f9604546d584...
00018b2dbaacca029e4714f0f85bc86c41a4b4a3df8fcb...

Last 5 values
fffebe9316b77dc030834bdecf643e2f1d8d912a79bc45...
ffff04db2ba37d91b738fdac887d5744018d10c4d5504f...
ffff191aa04c113dcc5c71dbf04bebfb43ed03fe4f20fb...
ffff27cb2ef65222f5e6563ec7a1f0418610bdfef1f5cd...
ffff3005ff89346b011e6d35e35983e42a0bb5a2262d45...

Toggle details

First 5 values

Value	Count	Frequency (%)
000001857eec66f7d67ea918825c9980eebff5c10b36f3cbcf8b977dae2673f3	1	< 0.1%
0000133f443484b40bc632e3b8595c8348441b3899973f25a5375e915f84ef88	1	< 0.1%
000061121bf1a98d79c02f156af0cadec80ea1c68236e69c8a36d0b087878a78	1	< 0.1%
0000bf5a53db23cf7ccbe510f95c423b97f9604546d584b33b0054a411cf9429	1	< 0.1%
00018b2dbaacca029e4714f0f85bc86c41a4b4a3df8fcb4f459b464fb1a40e56	1	< 0.1%

Last 5 values

Value	Count	Frequency (%)
ffff3005ff89346b011e6d35e35983e42a0bb5a2262d45acb7af4baee64b373a	1	< 0.1%
ffff27cb2ef65222f5e6563ec7a1f0418610bdfef1f5cd14692ec66879869148	1	< 0.1%
ffff191aa04c113dcc5c71dbf04bebfb43ed03fe4f20fb5970129e9de77542ad	1	< 0.1%
ffff04db2ba37d91b738fdac887d5744018d10c4d5504ffdfe1e2a5a192b236c	1	< 0.1%
fffebe9316b77dc030834bdecf643e2f1d8d912a79bc45ff69ff1b509fae1126	1	< 0.1%

idade_emp_cat
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

1 a 5	59888
5 a 10	50244
> 20	32651
Other values (3)	57217

Toggle details

Common values
Composition

Value	Count	Frequency (%)
1 a 5	59888	29.9%
5 a 10	50244	25.1%
> 20	32651	16.3%
10 a 15	21391	10.7%
<= 1	20213	10.1%
15 a 20	15613	7.8%

Max length	7
Mean length	5.35694
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

idade_empresa_anos
Numeric

Distinct count	12625
Unique (%)	6.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	9.947989959
Minimum	0.01643835616
Maximum	89.44383562
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.01643835616
5-th percentile	0.4657534247
Q1	2.767123288
Median	6.704109589
Q3	14.45753425
95-th percentile	30.15616438
Maximum	89.44383562
Range	89.42739726
Interquartile range	11.69041096

Descriptive statistics

Standard deviation	9.607973303
Coef of variation	0.965820567
Kurtosis	1.500814832
Mean	9.947989959
MAD	7.548775603
Skewness	1.373912367
Sum	1989597.992
Variance	92.31315099
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[1.64383562e-02 2.87671233e-02 3.69863014e-02 4.52054795e-02 5.61643836e-02 ... 4.89684932e+01 5.20698630e+01 5.22917808e+01 5.67438356e+01 8.94438356e+01], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0.2054794521	261	0.1%
0.2082191781	244	0.1%
0.202739726	199	0.1%
0.2164383562	140	0.1%
7.331506849	128	0.1%
8.021917808	123	0.1%
0.2438356164	120	0.1%
0.2	119	0.1%
7.334246575	116	0.1%
0.7452054795	114	0.1%
Other values (12615)	198436	99.2%

Minimum 5 values

Value	Count	Frequency (%)
0.01643835616	1	< 0.1%
0.02739726027	11	< 0.1%
0.0301369863	72	< 0.1%
0.03287671233	85	< 0.1%
0.03561643836	70	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
89.44383562	1	< 0.1%
74.87123288	1	< 0.1%
72.43013699	1	< 0.1%
67.90136986	1	< 0.1%
63.71506849	1	< 0.1%

idade_media_socios
Numeric

Distinct count	764
Unique (%)	0.4%
Missing (%)	32.7%
Missing (n)	65438
Infinite (%)	0.0%
Infinite (n)	0

Mean	42.81210697
Minimum	4
Maximum	127
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	4
5-th percentile	24
Q1	33
Median	42
Q3	51
95-th percentile	65
Maximum	127
Range	123
Interquartile range	18

Descriptive statistics

Standard deviation	12.64238542
Coef of variation	0.2952993047
Kurtosis	0.1020027824
Mean	42.81210697
MAD	10.24207012
Skewness	0.5041636159
Sum	5760882.739
Variance	159.8299092
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	3757	1.9%
36	3748	1.9%
38	3604	1.8%
35	3562	1.8%
39	3515	1.8%
34	3510	1.8%
41	3496	1.7%
40	3489	1.7%
33	3489	1.7%
32	3370	1.7%
Other values (753)	99022	49.5%
(Missing)	65438	32.7%

Minimum 5 values

Value	Count	Frequency (%)
4	1	< 0.1%
5	1	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
7.5	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
127	1	< 0.1%
121	1	< 0.1%
117	1	< 0.1%
110	2	< 0.1%
108	2	< 0.1%

natureza_juridica_macro
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

OUTROS	138512
ENTIDADES EMPRESARIAIS	42874
ENTIDADES SEM FINS LUCRATIVOS	16088
Other values (4)	2526

Toggle details

Common values
Composition

Value	Count	Frequency (%)
OUTROS	138512	69.3%
ENTIDADES EMPRESARIAIS	42874	21.4%
ENTIDADES SEM FINS LUCRATIVOS	16088	8.0%
ADMINISTRACAO PUBLICA	1305	0.7%
CARGO POLITICO	693	0.3%
PESSOAS FISICAS	527	0.3%
INSTITUICOES EXTRATERRITORIAIS	1	< 0.1%

Max length	30
Mean length	11.42947
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_divisao
Categorical

Distinct count	87
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	792

COMERCIO VAREJISTA	74773
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS	16475
ALIMENTACAO	11876
Other values (83)	96084

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMERCIO VAREJISTA	74773	37.4%
ATIVIDADES DE ORGANIZACOES ASSOCIATIVAS	16475	8.2%
ALIMENTACAO	11876	5.9%
COMERCIO E REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	9633	4.8%
COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTORES E MOTOCICLETAS	7092	3.5%
OUTRAS ATIVIDADES DE SERVICOS PESSOAIS	6783	3.4%
SERVICOS ESPECIALIZADOS PARA CONSTRUCAO	6137	3.1%
TRANSPORTE TERRESTRE	4884	2.4%
EDUCACAO	4851	2.4%
CONSTRUCAO DE EDIFICIOS	4249	2.1%
Other values (76)	52455	26.2%

Max length	120
Mean length	32.88121
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_meso_regiao
Categorical

Distinct count	20
Unique (%)	< 0.1%
Missing (%)	12.6%
Missing (n)	25254

CENTRO AMAZONENSE	30864
NORTE MARANHENSE	26524
LESTE POTIGUAR	25571
Other values (16)	91787
(Missing)	25254

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CENTRO AMAZONENSE	30864	15.4%
NORTE MARANHENSE	26524	13.3%
LESTE POTIGUAR	25571	12.8%
CENTRO NORTE PIAUIENSE	18283	9.1%
OESTE MARANHENSE	11590	5.8%
OESTE POTIGUAR	9076	4.5%
LESTE MARANHENSE	7588	3.8%
VALE DO ACRE	7181	3.6%
CENTRO MARANHENSE	6027	3.0%
SUDOESTE PIAUIENSE	5258	2.6%
Other values (9)	26784	13.4%
(Missing)	25254	12.6%

Max length	22
Mean length	14.59602
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_micro_regiao
Categorical

Distinct count	74
Unique (%)	< 0.1%
Missing (%)	12.6%
Missing (n)	25254

MANAUS	25887
NATAL	20273
AGLOMERACAO URBANA DE SAO LUIS	19833
Other values (70)	108753
(Missing)	25254

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MANAUS	25887	12.9%
NATAL	20273	10.1%
AGLOMERACAO URBANA DE SAO LUIS	19833	9.9%
TERESINA	14630	7.3%
IMPERATRIZ	6829	3.4%
RIO BRANCO	6111	3.1%
MOSSORO	4646	2.3%
PINDARE	3619	1.8%
MACAIBA	3213	1.6%
LITORAL PIAUIENSE	2958	1.5%
Other values (63)	66747	33.4%
(Missing)	25254	12.6%

Max length	33
Mean length	11.095095
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nm_segmento
Categorical

Distinct count	22
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	792

COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	91498
OUTRAS ATIVIDADES DE SERVICOS	25709
INDUSTRIAS DE TRANSFORMACAO	13897
Other values (18)	68104

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E MOTOCICLETAS	91498	45.7%
OUTRAS ATIVIDADES DE SERVICOS	25709	12.9%
INDUSTRIAS DE TRANSFORMACAO	13897	6.9%
ALOJAMENTO E ALIMENTACAO	13022	6.5%
CONSTRUCAO	11037	5.5%
ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEMENTARES	9216	4.6%
ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	7452	3.7%
TRANSPORTE ARMAZENAGEM E CORREIO	6618	3.3%
EDUCACAO	4851	2.4%
SAUDE HUMANA E SERVICOS SOCIAIS	4423	2.2%
Other values (11)	11485	5.7%

Max length	65
Mean length	42.540665
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

nu_meses_rescencia
Numeric

Distinct count	51
Unique (%)	< 0.1%
Missing (%)	9.8%
Missing (n)	19547
Infinite (%)	0.0%
Infinite (n)	0

Mean	24.99726245
Minimum	0
Maximum	66
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	9
Q1	22
Median	23
Q3	25
95-th percentile	48
Maximum	66
Range	66
Interquartile range	3

Descriptive statistics

Standard deviation	9.674244591
Coef of variation	0.3870121623
Kurtosis	1.961121154
Mean	24.99726245
MAD	5.873673916
Skewness	1.26387979
Sum	4510831
Variance	93.5910084
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	47070	23.5%
22	38641	19.3%
24	19297	9.6%
48	11375	5.7%
25	10805	5.4%
26	10475	5.2%
27	8130	4.1%
21	5283	2.6%
7	4371	2.2%
47	4218	2.1%
Other values (40)	20788	10.4%
(Missing)	19547	9.8%

Minimum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	2	< 0.1%
2	3	< 0.1%
5	1	< 0.1%
7	4371	2.2%

Maximum 5 values

Value	Count	Frequency (%)
66	18	< 0.1%
65	17	< 0.1%
64	3	< 0.1%
54	679	0.3%
53	14	< 0.1%

qt_filiais
Numeric

Distinct count	277
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	27.51195
Minimum	0
Maximum	9647
Zeros (%)	90.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	2
Maximum	9647
Range	9647
Interquartile range	0

Descriptive statistics

Standard deviation	459.1047766
Coef of variation	16.68746768
Kurtosis	374.733309
Mean	27.51195
MAD	53.66682345
Skewness	19.13128244
Sum	5502390
Variance	210777.1959
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 1.5000e+00 2.5000e+00 3.5000e+00 ... 5.2110e+03 5.4670e+03 8.4785e+03 9.3405e+03 9.6470e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	180959	90.5%
1	8441	4.2%
2	2549	1.3%
3	1238	0.6%
4	783	0.4%
5	489	0.2%
6	343	0.2%
7	294	0.1%
8	232	0.1%
10	213	0.1%
Other values (267)	4459	2.2%

Minimum 5 values

Value	Count	Frequency (%)
0	180959	90.5%
1	8441	4.2%
2	2549	1.3%
3	1238	0.6%
4	783	0.4%

Maximum 5 values

Value	Count	Frequency (%)
9647	105	0.1%
9411	123	0.1%
9270	164	0.1%
7687	65	< 0.1%
5491	39	< 0.1%

qt_socios
Numeric

Distinct count	47
Unique (%)	< 0.1%
Missing (%)	24.8%
Missing (n)	49616
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.484765667
Minimum	1
Maximum	153
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	2
95-th percentile	3
Maximum	153
Range	152
Interquartile range	1

Descriptive statistics

Standard deviation	3.124724546
Coef of variation	2.104523708
Kurtosis	825.9712659
Mean	1.484765667
MAD	0.72188127
Skewness	26.71097273
Sum	223285
Variance	9.763903487
Memory size	8.1 MiB

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	111971	56.0%
2	30747	15.4%
3	3831	1.9%
4	1395	0.7%
5	717	0.4%
6	420	0.2%
8	317	0.2%
7	263	0.1%
9	118	0.1%
96	105	0.1%
Other values (36)	500	0.2%
(Missing)	49616	24.8%

Minimum 5 values

Value	Count	Frequency (%)
1	111971	56.0%
2	30747	15.4%
3	3831	1.9%
4	1395	0.7%
5	717	0.4%

Maximum 5 values

Value	Count	Frequency (%)
153	1	< 0.1%
142	1	< 0.1%
139	1	< 0.1%
109	15	< 0.1%
96	105	0.1%

qt_socios_feminino
Numeric

Distinct count	23
Unique (%)	< 0.1%
Missing (%)	68.6%
Missing (n)	137299
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.107079632
Minimum	1
Maximum	93
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	2
Maximum	93
Range	92
Interquartile range	0

Descriptive statistics

Standard deviation	0.6837725746
Coef of variation	0.6176363063
Kurtosis	6196.851084
Mean	1.107079632
MAD	0.1977304021
Skewness	56.06299548
Sum	69415
Variance	0.4675449338
Memory size	8.1 MiB

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
1	57891	28.9%
2	3974	2.0%
3	533	0.3%
4	148	0.1%
5	63	< 0.1%
6	25	< 0.1%
15	16	< 0.1%
9	12	< 0.1%
7	11	< 0.1%
8	10	< 0.1%
Other values (12)	18	< 0.1%
(Missing)	137299	68.6%

Minimum 5 values

Value	Count	Frequency (%)
1	57891	28.9%
2	3974	2.0%
3	533	0.3%
4	148	0.1%
5	63	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
93	1	< 0.1%
59	1	< 0.1%
25	2	< 0.1%
24	1	< 0.1%
22	2	< 0.1%

qt_socios_masculino
Highly correlated

This variable is highly correlated with qt_socios and should be ignored for analysis

Correlation	0.9711913029

qt_socios_pj
Numeric

Distinct count	13
Unique (%)	< 0.1%
Missing (%)	24.8%
Missing (n)	49616
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.01907117778
Minimum	0
Maximum	13
Zeros (%)	74.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	13
Range	13
Interquartile range	0

Descriptive statistics

Standard deviation	0.1943337274
Coef of variation	10.18991745
Kurtosis	480.7900332
Mean	0.01907117778
MAD	0.03765867731
Skewness	16.26400576
Sum	2868
Variance	0.03776559759
Memory size	8.1 MiB

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	148477	74.2%
1	1173	0.6%
2	602	0.3%
3	86	< 0.1%
4	31	< 0.1%
5	5	< 0.1%
7	3	< 0.1%
6	2	< 0.1%
9	2	< 0.1%
13	1	< 0.1%
Other values (2)	2	< 0.1%
(Missing)	49616	24.8%

Minimum 5 values

Value	Count	Frequency (%)
0	148477	74.2%
1	1173	0.6%
2	602	0.3%
3	86	< 0.1%
4	31	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
13	1	< 0.1%
12	1	< 0.1%
9	2	< 0.1%
8	1	< 0.1%
7	3	< 0.1%

setor
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	792

COMERCIO	91498
SERVIÇO	81829
INDUSTRIA	13424
Other values (2)	12457

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMERCIO	91498	45.7%
SERVIÇO	81829	40.9%
INDUSTRIA	13424	6.7%
CONSTRUÇÃO CIVIL	11037	5.5%
AGROPECUARIA	1420	0.7%
(Missing)	792	0.4%

Max length	16
Mean length	8.108055
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

sg_uf
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

MA	55257
RN	42877
AM	35370
Other values (3)	66496

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MA	55257	27.6%
RN	42877	21.4%
AM	35370	17.7%
PI	33279	16.6%
RO	24317	12.2%
AC	8900	4.5%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

sg_uf_matriz
Categorical

Distinct count	28
Unique (%)	< 0.1%
Missing (%)	0.4%
Missing (n)	795

MA	54056
RN	42015
AM	34489
Other values (24)	68645

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MA	54056	27.0%
RN	42015	21.0%
AM	34489	17.2%
PI	32628	16.3%
RO	23662	11.8%
AC	8651	4.3%
SP	1258	0.6%
DF	505	0.3%
CE	404	0.2%
RJ	276	0.1%
Other values (17)	1261	0.6%
(Missing)	795	0.4%

Max length	3
Mean length	2.003975
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

Unnamed_0.1
Numeric

Distinct count	200000
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	99999.5
Minimum	0
Maximum	199999
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	9999.95
Q1	49999.75
Median	99999.5
Q3	149999.25
95-th percentile	189999.05
Maximum	199999
Range	199999
Interquartile range	99999.5

Descriptive statistics

Standard deviation	57735.17126
Coef of variation	0.5773545993
Kurtosis	-1.2
Mean	99999.5
MAD	50000
Skewness	0
Sum	1.99999e+10
Variance	3333350000
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 199999.], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2047	1	< 0.1%
152928	1	< 0.1%
189814	1	< 0.1%
195957	1	< 0.1%
193908	1	< 0.1%
183667	1	< 0.1%
181618	1	< 0.1%
187761	1	< 0.1%
185712	1	< 0.1%
142703	1	< 0.1%
Other values (199990)	199990	> 99.9%

Minimum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
199999	1	< 0.1%
199998	1	< 0.1%
199997	1	< 0.1%
199996	1	< 0.1%
199995	1	< 0.1%

vl_faturamento_estimado_aux
Numeric

Distinct count	1225
Unique (%)	0.6%
Missing (%)	5.9%
Missing (n)	11885
Infinite (%)	0.0%
Infinite (n)	0

Mean	789491.3819
Minimum	0
Maximum	1.4546625e+10
Zeros (%)	0.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	50000
Q1	164851.2
Median	210000
Q3	210000
95-th percentile	947894.4
Maximum	1.4546625e+10
Range	1.4546625e+10
Interquartile range	45148.8

Descriptive statistics

Standard deviation	36398055.47
Coef of variation	46.1031701
Kurtosis	136074.6802
Mean	789491.3819
MAD	1096986.45
Skewness	346.5212661
Sum	1.485151713e+11
Variance	1.324818442e+15
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210000	108120	54.1%
50000	40784	20.4%
930000	7060	3.5%
185457.6	3570	1.8%
370915.2	2796	1.4%
123638.4	2720	1.4%
247276.8	1675	0.8%
556372.8	1282	0.6%
741830.4	1220	0.6%
61819.2	943	0.5%
Other values (1214)	17945	9.0%
(Missing)	11885	5.9%

Minimum 5 values

Value	Count	Frequency (%)
0	507	0.3%
41212.8	849	0.4%
50000	40784	20.4%
51516	143	0.1%
61819.2	943	0.5%

Maximum 5 values

Value	Count	Frequency (%)
1.4546625e+10	1	< 0.1%
3220831700	1	< 0.1%
2068779500	1	< 0.1%
2048888000	1	< 0.1%
1489842700	1	< 0.1%

vl_faturamento_estimado_grupo_aux
Numeric

Distinct count	4416
Unique (%)	2.2%
Missing (%)	5.9%
Missing (n)	11885
Infinite (%)	0.0%
Infinite (n)	0

Mean	306243925.2
Minimum	41212.8
Maximum	2.227618e+11
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	41212.8
5-th percentile	50000
Q1	185457.6
Median	210000
Q3	210000
95-th percentile	2827058.91
Maximum	2.227618e+11
Range	2.227617588e+11
Interquartile range	24542.4

Descriptive statistics

Standard deviation	6677856568
Coef of variation	21.80567848
Kurtosis	837.9308527
Mean	306243925.2
MAD	602867603.8
Skewness	28.13600343
Sum	5.760907598e+13
Variance	4.459376835e+19
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210000	99930	50.0%
50000	40784	20.4%
930000	5612	2.8%
185457.6	3111	1.6%
420000	2999	1.5%
123638.4	2450	1.2%
370915.2	2387	1.2%
247276.8	1455	0.7%
556372.8	1075	0.5%
741830.4	1028	0.5%
Other values (4405)	27284	13.6%
(Missing)	11885	5.9%

Minimum 5 values

Value	Count	Frequency (%)
41212.8	773	0.4%
50000	40784	20.4%
51516	135	0.1%
61819.2	820	0.4%
82425.6	257	0.1%

Maximum 5 values

Value	Count	Frequency (%)
2.227618e+11	65	< 0.1%
1.8943014e+11	105	0.1%
1.8120853e+11	15	< 0.1%
1.2398112e+11	4	< 0.1%
1.009873e+11	8	< 0.1%

vl_total_veiculos_leves_grupo
Numeric

Distinct count	250
Unique (%)	0.1%
Missing (%)	0.4%
Missing (n)	792
Infinite (%)	0.0%
Infinite (n)	0

Mean	48.27108349
Minimum	0
Maximum	122090
Zeros (%)	91.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	122090
Range	122090
Interquartile range	0

Descriptive statistics

Standard deviation	1212.466738
Coef of variation	25.11786872
Kurtosis	1708.785325
Mean	48.27108349
MAD	95.14304612
Skewness	35.27165009
Sum	9615986
Variance	1470075.591
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	183714	91.9%
1	6793	3.4%
2	2247	1.1%
3	1111	0.6%
4	670	0.3%
5	460	0.2%
6	333	0.2%
7	269	0.1%
8	231	0.1%
10	176	0.1%
Other values (239)	3204	1.6%
(Missing)	792	0.4%

Minimum 5 values

Value	Count	Frequency (%)
0	183714	91.9%
1	6793	3.4%
2	2247	1.1%
3	1111	0.6%
4	670	0.3%

Maximum 5 values

Value	Count	Frequency (%)
122090	1	< 0.1%
105312	1	< 0.1%
96763	1	< 0.1%
44229	1	< 0.1%
44175	1	< 0.1%

vl_total_veiculos_pesados_grupo
Numeric

Distinct count	228
Unique (%)	0.1%
Missing (%)	0.4%
Missing (n)	792
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.454509859
Minimum	0
Maximum	3674
Zeros (%)	95.6%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	3674
Range	3674
Interquartile range	0

Descriptive statistics

Standard deviation	69.53233698
Coef of variation	20.12798916
Kurtosis	868.4489056
Mean	3.454509859
MAD	6.71861698
Skewness	27.93113919
Sum	688166
Variance	4834.745886
Memory size	8.1 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	191111	95.6%
1	2913	1.5%
2	1105	0.6%
3	548	0.3%
4	378	0.2%
5	278	0.1%
7	230	0.1%
6	198	0.1%
1177	164	0.1%
8	128	0.1%
Other values (217)	2155	1.1%
(Missing)	792	0.4%

Minimum 5 values

Value	Count	Frequency (%)
0	191111	95.6%
1	2913	1.5%
2	1105	0.6%
3	548	0.3%
4	378	0.2%

Maximum 5 values

Value	Count	Frequency (%)
3674	1	< 0.1%
2710	1	< 0.1%
2693	4	< 0.1%
2347	105	0.1%
2151	1	< 0.1%

First rows

	de_faixa_faturamento_estimado	de_faixa_faturamento_estimado_grupo	de_natureza_juridica	de_nivel_atividade	de_ramo	de_saude_rescencia	de_saude_tributaria	dt_situacao	empsetorcensitariofaixarendapopulacao	fl_antt	fl_email	fl_epp	fl_ltda	fl_matriz	fl_me	fl_mei	fl_optante_simei	fl_optante_simples	fl_passivel_iss	fl_rm	fl_sa	fl_simples_irregular	fl_spa	fl_st_especial	fl_telefone	fl_veiculo	id	idade_emp_cat	idade_empresa_anos	idade_media_socios	natureza_juridica_macro	nm_divisao	nm_meso_regiao	nm_micro_regiao	nm_segmento	nu_meses_rescencia	qt_filiais	qt_socios	qt_socios_feminino	qt_socios_masculino	qt_socios_pj	setor	sg_uf	sg_uf_matriz	Unnamed_0.1	vl_faturamento_estimado_aux	vl_faturamento_estimado_grupo_aux
0	DE R$ 1.500.000,01 A R$ 4.800.000,00	DE R$ 1.500.000,01 A R$ 4.800.000,00	SOCIEDADE EMPRESARIA LIMITADA	ALTA	INDUSTRIA DA CONSTRUCAO	ACIMA DE 1 ANO	VERDE	2005-03-25	NaN	False	True	False	False	True	False	False	False	True	True	SIM	False	False	False	False	True	False	a6984c3ae395090e3bee8ad63c3758b110de096d5d8195...	10 a 15	14.457534	44.0	ENTIDADES EMPRESARIAIS	CONSTRUCAO DE EDIFICIOS	LESTE POTIGUAR	NATAL	CONSTRUCAO	23.0	0	2.0	NaN	2.0	0.0	CONSTRUÇÃO CIVIL	RN	RN	0	3132172.8	3132172.8
1	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	BAIXA	SERVICOS DE ALOJAMENTO/ALIMENTACAO	ATE 1 ANO	CINZA	2017-05-12	468.93	False	True	False	False	True	False	True	NaN	NaN	True	SIM	False	False	False	False	True	False	6178f41ade1365e44bc2c46654c2c8c0eaae27dcb476c4...	1 a 5	1.463014	27.0	OUTROS	ALIMENTACAO	CENTRO NORTE PIAUIENSE	TERESINA	ALOJAMENTO E ALIMENTACAO	9.0	0	1.0	NaN	1.0	0.0	SERVIÇO	PI	PI	1	210000.0	210000.0
2	ATE R$ 81.000,00	ATE R$ 81.000,00	EMPRESARIO INDIVIDUAL	MEDIA	TRANSPORTE, ARMAZENAGEM E CORREIO	ACIMA DE 1 ANO	AMARELO	2011-09-26	713.50	False	False	False	False	True	False	True	True	True	True	SIM	False	False	False	False	True	False	4a7e5069a397f12fdd7fd57111d6dc5d3ba558958efc02...	5 a 10	7.093151	32.0	OUTROS	TRANSPORTE TERRESTRE	CENTRO AMAZONENSE	MANAUS	TRANSPORTE ARMAZENAGEM E CORREIO	26.0	0	1.0	NaN	1.0	0.0	SERVIÇO	AM	AM	2	50000.0	50000.0
3	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	MEDIA	SERVICOS DIVERSOS	ACIMA DE 1 ANO	AMARELO	2012-04-25	475.73	False	True	False	False	True	False	False	False	True	True	SIM	False	False	False	False	True	False	3348900fe63216a439d2e5238c79ddd46ede454df7b9d8...	5 a 10	6.512329	36.0	OUTROS	REPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO...	CENTRO AMAZONENSE	MANAUS	OUTRAS ATIVIDADES DE SERVICOS	26.0	0	1.0	NaN	1.0	0.0	SERVIÇO	AM	AM	3	210000.0	210000.0
4	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	ALTA	SERVICOS PROFISSIONAIS, TECNICOS E CIENTIFICOS	ACIMA DE 1 ANO	VERDE	2015-08-17	2874.04	False	True	False	False	True	False	False	False	True	True	SIM	False	False	False	False	True	False	1f9bcabc9d3173c1fe769899e4fac14b053037b953a1e4...	1 a 5	3.200000	NaN	OUTROS	SERVICOS DE ARQUITETURA E ENGENHARIA TESTES E ...	LESTE POTIGUAR	NATAL	ATIVIDADES PROFISSIONAIS CIENTIFICAS E TECNICAS	27.0	0	1.0	NaN	NaN	0.0	SERVIÇO	RN	RN	4	210000.0	210000.0
5	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	SOCIEDADE EMPRESARIA LIMITADA	ALTA	QUIMICA-PETROQUIMICA	ACIMA DE 1 ANO	LARANJA	2005-11-03	NaN	False	False	False	False	True	False	False	False	False	False	NAO	False	False	False	False	False	False	529a1f5fc6f88071db7d38492a0ce7c985c77e9b1c3bb6...	> 20	38.079452	NaN	ENTIDADES EMPRESARIAIS	FABRICACAO DE PRODUTOS DE MINERAIS NAO METALICOS	OESTE POTIGUAR	PAU DOS FERROS	INDUSTRIAS DE TRANSFORMACAO	48.0	0	NaN	NaN	NaN	NaN	INDUSTRIA	RN	RN	5	210000.0	210000.0
6	ATE R$ 81.000,00	ATE R$ 81.000,00	EMPRESARIO INDIVIDUAL	MEDIA	TRANSPORTE, ARMAZENAGEM E CORREIO	ACIMA DE 1 ANO	AMARELO	2011-07-21	NaN	False	True	False	False	True	False	True	True	True	True	SIM	False	False	False	False	False	False	8bf37c178778e537b108e58bf20552abe10c3a7fae129b...	5 a 10	7.276712	63.0	OUTROS	TRANSPORTE TERRESTRE	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	TRANSPORTE ARMAZENAGEM E CORREIO	23.0	0	1.0	NaN	1.0	0.0	SERVIÇO	MA	MA	6	50000.0	50000.0
7	NaN	NaN	EMPRESARIO INDIVIDUAL	ALTA	SERVICOS ADMINISTRATIVOS	NaN	NaN	2018-10-09	NaN	False	True	False	False	True	False	True	NaN	NaN	True	SIM	False	False	False	False	True	False	0114fd3fbdc347c561843cde6aece12e8e53cb5d32c77d...	<= 1	0.052055	40.0	OUTROS	AGENCIAS DE VIAGENS OPERADORES TURISTICOS E SE...	LESTE POTIGUAR	NATAL	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...	NaN	0	1.0	1.0	NaN	0.0	SERVIÇO	RN	RN	7	NaN	NaN
8	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	COOPERATIVA	ALTA	BENS DE CONSUMO	ACIMA DE 1 ANO	AZUL	2006-07-27	247.88	False	False	False	False	True	False	False	False	True	True	NAO	False	False	False	False	True	False	6c45aabb849a760a3a7107c7a61262642f683feb8912a4...	10 a 15	12.263014	36.0	ENTIDADES EMPRESARIAIS	FABRICACAO DE PRODUTOS DIVERSOS	CENTRO AMAZONENSE	PARINTINS	INDUSTRIAS DE TRANSFORMACAO	24.0	0	2.0	NaN	1.0	0.0	INDUSTRIA	AM	AM	8	210000.0	210000.0
9	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 360.000,01 A R$ 1.500.000,00	EMPRESARIO INDIVIDUAL	MEDIA	COMERCIO VAREJISTA	ACIMA DE 1 ANO	VERMELHO	2004-10-30	1042.85	False	False	False	False	False	False	False	False	False	False	NAO	False	False	False	False	False	False	2fcd678d71b04ccb77644fff57706bdc7fcfbbec6b1926...	15 a 20	17.942466	52.0	OUTROS	COMERCIO VAREJISTA	OESTE POTIGUAR	MOSSORO	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...	54.0	3	1.0	NaN	1.0	0.0	COMERCIO	RN	RN	9	210000.0	840000.0

Last rows

	de_faixa_faturamento_estimado	de_faixa_faturamento_estimado_grupo	de_natureza_juridica	de_nivel_atividade	de_ramo	de_saude_rescencia	de_saude_tributaria	dt_situacao	empsetorcensitariofaixarendapopulacao	fl_antt	fl_email	fl_epp	fl_ltda	fl_matriz	fl_me	fl_mei	fl_optante_simei	fl_optante_simples	fl_passivel_iss	fl_rm	fl_sa	fl_simples_irregular	fl_spa	fl_st_especial	fl_telefone	fl_veiculo	id	idade_emp_cat	idade_empresa_anos	idade_media_socios	natureza_juridica_macro	nm_divisao	nm_meso_regiao	nm_micro_regiao	nm_segmento	nu_meses_rescencia	qt_filiais	qt_socios	qt_socios_feminino	qt_socios_masculino	qt_socios_pj	setor	sg_uf	sg_uf_matriz	Unnamed_0.1	vl_faturamento_estimado_aux	vl_faturamento_estimado_grupo_aux	vl_total_veiculos_leves_grupo	vl_total_veiculos_pesados_grupo
199990	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	MEDIA	SERVICOS ADMINISTRATIVOS	ACIMA DE 1 ANO	AZUL	2013-08-08	958.09	False	False	False	False	True	False	False	False	False	True	NAO	False	False	False	False	True	False	b3842201eb905c46f0eb4a7b93a7ff34388d3e3f8f83c2...	5 a 10	5.224658	NaN	OUTROS	SERVICOS DE ESCRITORIO DE APOIO ADMINISTRATIVO...	NORTE MARANHENSE	LENCOIS MARANHENSES	ATIVIDADES ADMINISTRATIVAS E SERVICOS COMPLEME...	23.0	0	NaN	NaN	NaN	NaN	SERVIÇO	MA	MA	199990	210000.0	210000.0	0.0	0.0
199991	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	MEDIA	COMERCIO VAREJISTA	ACIMA DE 1 ANO	AMARELO	2005-11-03	NaN	False	False	False	False	True	False	False	False	False	False	SIM	False	False	False	False	False	False	5057d28fa6432ccf08a7d2c7b3b6a069962392b5265531...	15 a 20	16.558904	47.0	OUTROS	COMERCIO VAREJISTA	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...	24.0	0	1.0	NaN	1.0	0.0	COMERCIO	MA	MA	199991	210000.0	210000.0	0.0	0.0
199992	ATE R$ 81.000,00	ATE R$ 81.000,00	EMPRESARIO INDIVIDUAL	ALTA	SERVICOS DIVERSOS	ACIMA DE 1 ANO	VERDE	2008-12-30	NaN	False	True	False	False	True	False	False	True	True	True	NAO	False	False	False	False	True	False	7665c89ce3d3cd35a8c1f71472da744e78a44115a2a371...	5 a 10	9.832877	NaN	OUTROS	OUTRAS ATIVIDADES DE SERVICOS PESSOAIS	OESTE POTIGUAR	SERRA DE SAO MIGUEL	OUTRAS ATIVIDADES DE SERVICOS	23.0	0	1.0	NaN	NaN	0.0	SERVIÇO	RN	RN	199992	50000.0	50000.0	0.0	0.0
199993	ATE R$ 81.000,00	ATE R$ 81.000,00	EMPRESARIO INDIVIDUAL	ALTA	SERVICOS DE ALOJAMENTO/ALIMENTACAO	ACIMA DE 1 ANO	VERDE	2011-02-25	NaN	False	False	False	False	True	False	True	True	True	True	SIM	False	False	False	False	True	False	6b836412910d230bcba8c9d14aa588bf5dfcd7c37859b2...	5 a 10	7.676712	40.0	OUTROS	ALIMENTACAO	CENTRO AMAZONENSE	ITACOATIARA	ALOJAMENTO E ALIMENTACAO	25.0	0	1.0	1.0	NaN	0.0	SERVIÇO	AM	AM	199993	50000.0	50000.0	0.0	0.0
199994	NaN	NaN	SOCIEDADE EMPRESARIA LIMITADA	NaN	INDUSTRIA DA CONSTRUCAO	NaN	NaN	2017-08-03	NaN	False	True	False	False	False	False	False	NaN	NaN	False	SIM	False	False	False	False	True	False	af91fa4a0cafef1a39e2c79e9eaf0f76344be166cd081e...	1 a 5	1.235616	47.0	ENTIDADES EMPRESARIAIS	CONSTRUCAO DE EDIFICIOS	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	CONSTRUCAO	NaN	4	2.0	1.0	1.0	0.0	CONSTRUÇÃO CIVIL	MA	MA	199994	NaN	NaN	3.0	3.0
199995	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	SOCIEDADE EMPRESARIA LIMITADA	MEDIA	SERVICOS DE ALOJAMENTO/ALIMENTACAO	ACIMA DE 1 ANO	AZUL	2013-09-27	707.86	False	False	False	False	True	False	False	False	True	True	SIM	False	False	False	False	True	False	47374fcdc31fe94bc9190e9c5d31ee8976307f8082bff1...	5 a 10	5.087671	72.0	ENTIDADES EMPRESARIAIS	ALIMENTACAO	NORTE MARANHENSE	AGLOMERACAO URBANA DE SAO LUIS	ALOJAMENTO E ALIMENTACAO	22.0	0	2.0	NaN	1.0	0.0	SERVIÇO	MA	MA	199995	247276.8	247276.8	0.0	0.0
199996	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	MEDIA	COMERCIO POR ATACADO	ACIMA DE 1 ANO	AZUL	2008-02-15	1443.43	False	False	False	False	True	False	False	False	False	False	NAO	False	False	False	False	True	False	8a14502b3bfdd18f702df8895a800c4bba3bfd42f10028...	10 a 15	10.706849	NaN	OUTROS	COMERCIO POR ATACADO EXCETO VEICULOS AUTOMOTOR...	NaN	NaN	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...	24.0	0	NaN	NaN	NaN	NaN	COMERCIO	RO	RO	199996	210000.0	210000.0	0.0	0.0
199997	ATE R$ 81.000,00	ATE R$ 81.000,00	EMPRESARIO INDIVIDUAL	MEDIA	COMERCIO VAREJISTA	ACIMA DE 1 ANO	VERDE	2013-04-24	NaN	False	False	False	False	True	False	True	True	True	False	NAO	False	False	False	False	True	False	ba3b7f728587f83023464d54ea06fa5628b3ba8d1aeeb0...	5 a 10	5.515068	46.0	OUTROS	COMERCIO VAREJISTA	LESTE MARANHENSE	CHAPADAS DO ALTO ITAPECURU	COMERCIO; REPARACAO DE VEICULOS AUTOMOTORES E ...	24.0	0	1.0	NaN	1.0	0.0	COMERCIO	MA	MA	199997	50000.0	50000.0	0.0	0.0
199998	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	EMPRESARIO INDIVIDUAL	BAIXA	SERVICOS DIVERSOS	ATE 1 ANO	CINZA	2017-07-17	NaN	False	True	False	False	True	False	True	NaN	NaN	True	NAO	False	False	False	False	True	False	eb4ddd433569ecc02bceb40901ba56ba786d48b946e9a4...	1 a 5	1.282192	22.0	OUTROS	REPARACAO E MANUTENCAO DE EQUIPAMENTOS DE INFO...	NaN	NaN	OUTRAS ATIVIDADES DE SERVICOS	7.0	0	1.0	NaN	1.0	0.0	SERVIÇO	RO	RO	199998	210000.0	210000.0	0.0	0.0
199999	DE R$ 81.000,01 A R$ 360.000,00	DE R$ 81.000,01 A R$ 360.000,00	SOCIEDADE EMPRESARIA LIMITADA	ALTA	INDUSTRIA DA CONSTRUCAO	ACIMA DE 1 ANO	VERDE	2012-05-17	439.41	False	True	False	False	True	False	False	False	False	True	NAO	False	False	False	False	False	False	099b001d8cdbae0c349cf66c3b0fe1f04c27a06ac58b6d...	5 a 10	6.452055	45.0	ENTIDADES EMPRESARIAIS	CONSTRUCAO DE EDIFICIOS	OESTE POTIGUAR	PAU DOS FERROS	CONSTRUCAO	48.0	0	2.0	2.0	NaN	0.0	CONSTRUÇÃO CIVIL	RN	RN	199999	210000.0	210000.0	0.0	0.0

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows